package com.yuda.campsite.mapper;

/**
 * @Author: xiaohudie
 * @Date: 2021/12/9 10:04
 * @Version: 1.8
 */

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.*;

/**发送邮件的orm接口*/
public interface SendEmailMapper {

    /**根据条件查找学生的邮箱*/
    public List<String> ChaXunEmail    (@Param("campsiteId") String campsiteId,
                                        @Param("status") String status,
                                        @Param("examineStatus") String examineStatus,
                                        @Param("invitationCode") String invitationCode);
    /**根据条件查询studentInfo表中的email*/
    public List<String> ChaXunStuEamil   (@Param("campsiteId") String campsiteId,
                                          @Param("status") String status,
                                          @Param("examineStatus") String examineStatus,
                                          @Param("invitationCode") String invitationCode);
   /**根据条件查询在studentAccount表中的手机号码*/
   public List<String> SelectPhoneStuAccount (@Param("campsiteId") String campsiteId,
                                              @Param("status") String status,
                                              @Param("examineStatus") String examineStatus,
                                              @Param("invitationCode") String invitationCode);
   /**根据条件查询在studentInfo表中的手机号码*/
   public List<String> SelectPhoneStudentInfo (@Param("campsiteId") String campsiteId,
                                               @Param("status") String status,
                                               @Param("examineStatus") String examineStatus,
                                               @Param("invitationCode") String invitationCode);
}
